# -*- coding: utf-8 -*-
Session = sessionmaker(bind=engine)
session = Session()
aluno1=Aluno('Tiago Bond','007','Espeleologia')
aluno2=Aluno('Barbara Bond' '008', 'Comunicacao')
aluno3=Aluno('Manuel Bond', '009', 'Filosofia')
session.add(aluno1); session.add(aluno2);
session.add(aluno3)
session.commit()
for obj in session.query(Aluno):
	print obj.nome
print
for obj in session.query(Aluno).filter(Aluno.nome=='Barbara Bond'):
	print obj.nome, obj.numero, obj.curso